UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jzgIriNrbs1srgB5AZGbUUyIh4yucr8JkfNEIAMhVHA='
WHERE
key_id = '10785ad9a77e1b739afea2e5a6639e53f7d6f58d0a25c5b90160cf853a402861'
AND (
token = 'jzgIriNrbs1srgB5AZGbUUyIh4yucr8JkfNEIAMhVHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)