UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hDzU9kgLMxAg6pnFEblerkdOuiz6aFNrA9NLt78pkt4='
WHERE
key_id = '65e36a74c6548ac752822ff2e5c335d3ce6ba91aa9a6fe7d0dec2039599baad3'
AND (
token = 'hDzU9kgLMxAg6pnFEblerkdOuiz6aFNrA9NLt78pkt4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)