UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4S/sXd5Aw1I3UbB8KjR8CHXzIuWZblxhzNDruHw7Nf8='
WHERE
key_id = '6017dc20dba3fdf3ac92e8a7cdd0357b7a3944a66faf8011f3a93170deb2f729'
AND (
token = '4S/sXd5Aw1I3UbB8KjR8CHXzIuWZblxhzNDruHw7Nf8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)