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