UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uNk0IYgVoei7EFHNFYAI16Cp2BvtXQtAAjUoeAfGTHw='
WHERE
key_id = 'd4e9bebe6bb0ee647b2a9acd56bebfe30235747dc7b0bde819897b1c43199f5b'
AND (
token = 'uNk0IYgVoei7EFHNFYAI16Cp2BvtXQtAAjUoeAfGTHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)