UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JW79UfKtFBBYzspK2BpFWuu6DfHq0Qj3Jam/d45cL2g='
WHERE
key_id = 'ceefe8f07b1b058f5041401c4a670136cd6fc2e98ac3ad493c6d2f62d2caf597'
AND (
token = 'JW79UfKtFBBYzspK2BpFWuu6DfHq0Qj3Jam/d45cL2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)