UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8CsN1xp1hMgqTS79iSncOJOI9+adKDPWANBTaJ0rL4k='
WHERE
key_id = '9218c4d92870881a99502cbf171cf6fc93186eac11ce2f372c789e303e320bb3'
AND (
token = '8CsN1xp1hMgqTS79iSncOJOI9+adKDPWANBTaJ0rL4k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)