UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNCJ7lmOEzTSyAUsWjk7fxbt5ePTs70NNA3YaT/hvZk='
WHERE
key_id = '47ed106e69204d9b8bf51ee8711222c55d0c821888db789bb22d67aeef2c33b3'
AND (
token = 'nNCJ7lmOEzTSyAUsWjk7fxbt5ePTs70NNA3YaT/hvZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)