UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sDvlEIfAPZFv4IDjg+/8pv/w+/YixjizAcNvPv00F0='
WHERE
key_id = 'bf2cac70a17a3358b308ab2797c39495d3adb58b5f849900d38642e6fcdccbc4'
AND (
token = '0sDvlEIfAPZFv4IDjg+/8pv/w+/YixjizAcNvPv00F0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)