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