UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zQykcDoStBBgmbbjBV7JehRim3CfiEhyVsgmynrw+eY='
WHERE
key_id = '229815363bf5c9e00d9d191422b16bcfc468fc14def97d459b7a19e10b3f0ff4'
AND (
token = 'zQykcDoStBBgmbbjBV7JehRim3CfiEhyVsgmynrw+eY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)