UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vrXWcXNi53hwuMny3W9o4CufyHg7NS0vvBdvDAq+SCU='
WHERE
key_id = 'c646bc677297f606bf59e7df8c7a47516822ae04b8df34e3d4de993fc5b64602'
AND (
token = 'vrXWcXNi53hwuMny3W9o4CufyHg7NS0vvBdvDAq+SCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)