UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KYUN0d1ngsNhb1/NMFW65PCCTewbBsHr0MIoCVcd5A='
WHERE
key_id = '2a1703378567921499b8a4a1d41ee99de8728c8629cc6a42ac6fdefe486890f6'
AND (
token = '4KYUN0d1ngsNhb1/NMFW65PCCTewbBsHr0MIoCVcd5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)