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