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