UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9AvD+iPGa0dmaiggrWgqZK+8TnJ1y7fz535/rB+sEA='
WHERE
key_id = '6f618a3d5ff52621bc5cb1f05fe119b3e08521f37fa06216b278f1151ac3889c'
AND (
token = 'z9AvD+iPGa0dmaiggrWgqZK+8TnJ1y7fz535/rB+sEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)