UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHyjPZLEIseUCsky/RIAsx7wkAvLGHLG4b6exIoibpc='
WHERE
key_id = 'f04d93a05a36706bc022d5ca08f92f00514e09d1b0701fbb00741a460f68a40a'
AND (
token = 'ZHyjPZLEIseUCsky/RIAsx7wkAvLGHLG4b6exIoibpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)