UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CbOXsFEUtpNg24cd9E/s9W0Th/HigM7VRP1wUkHvjVw='
WHERE
key_id = '31d1dbd939a3b48f48597fb59e887220db26fcf718cf27b2fc0422658db2ef6a'
AND (
token = 'CbOXsFEUtpNg24cd9E/s9W0Th/HigM7VRP1wUkHvjVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)