UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nEX9dxX2sBHrOvlQ5v2FdgFeuKV2NTp9FpXxXw0eQCQ='
WHERE
key_id = 'de1e3e0ed887b87284ffe493e7f6a0be069aab0fe7ef7d7e9d3b71916e787fef'
AND (
token = 'nEX9dxX2sBHrOvlQ5v2FdgFeuKV2NTp9FpXxXw0eQCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)