UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42MM6r3plozrWe7gujYqxvBfcFN97wkVU2evhjI2J1s='
WHERE
key_id = '77806d10dfa301978a5261f75a0f98fac80f00893f8b06bb406b668a69e42012'
AND (
token = '42MM6r3plozrWe7gujYqxvBfcFN97wkVU2evhjI2J1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)