UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tkesBFreURV17smq7VYBOnmSmRJ4gwGQPU7NS9mM9Z8='
WHERE
key_id = '770eff01e9f5ba30e35abe4a14d20aa10fd1d0ff16d82e9e5059b214d3478432'
AND (
token = 'tkesBFreURV17smq7VYBOnmSmRJ4gwGQPU7NS9mM9Z8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)