UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VlNI8V8i+Q5qBwFkHqshsi1tPsoZg3knALGa0fJ1Pjg='
WHERE
key_id = 'c6a2aee0d9d57b6116e2694085b7090a4c94dfa2618f2e5d1355ae292dabe13e'
AND (
token = 'VlNI8V8i+Q5qBwFkHqshsi1tPsoZg3knALGa0fJ1Pjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)