UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNZojUmjo1Nfv197E/NbnV2h9Pz4b8lHt9mcOsqFeA0='
WHERE
key_id = '0620a35aaf7d05ec783426a8239ad9421bb6841394b886a2fd2feb70b43e3cb3'
AND (
token = 'zNZojUmjo1Nfv197E/NbnV2h9Pz4b8lHt9mcOsqFeA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)