UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p64CqLRfGHonDoqGmw3FZ1fACptSnhMztvrZ0sOJkHY='
WHERE
key_id = '21e7a0b112b8063adcbaa2848697e8202344233d3693b4052ac51212b89cdcc8'
AND (
token = 'p64CqLRfGHonDoqGmw3FZ1fACptSnhMztvrZ0sOJkHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)