UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CMJgAJoC8vFZ66HIhWF2N/UQupWBZYzqgyJke5aWWiw='
WHERE
key_id = '9b2348a2f0202947721f0f654eff8a84870d16c2f6f533c885c35299462a6478'
AND (
token = 'CMJgAJoC8vFZ66HIhWF2N/UQupWBZYzqgyJke5aWWiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)