UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vf8MnZpVfeJKcRYKC8VEe4sDk3xP66cBjnrHvQUvMyw='
WHERE
key_id = '1785fc1e42c7eaf88774cc4ba763f8331658cdd0cb94d521a854a1f04a961870'
AND (
token = 'Vf8MnZpVfeJKcRYKC8VEe4sDk3xP66cBjnrHvQUvMyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)