UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XM+kvNZFe4e6bI4KiHPxwyDpMiQ0N2bhHE4MbrJ05MU='
WHERE
key_id = '7811205cae11152e856c29d00427f45fddffa58f0270c7b9987cea87359d1145'
AND (
token = 'XM+kvNZFe4e6bI4KiHPxwyDpMiQ0N2bhHE4MbrJ05MU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)