UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZKG8UNqPU8A3K7qONPwzWztUs2upVxH2NeWE8jnF7fc='
WHERE
key_id = '9d6f37fa8711e53b5b883ee44219f38098dff25c1d8fd5524edd53a1c5ce2eed'
AND (
token = 'ZKG8UNqPU8A3K7qONPwzWztUs2upVxH2NeWE8jnF7fc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)