UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zo84VaaKTRtbcLUX9TQWFhAL49Dt/JsFMaj2PnybiDY='
WHERE
key_id = 'd6f75414402dcf7d53352ab584268181a94b8ae67ee2947c1403eeba3dba0836'
AND (
token = 'zo84VaaKTRtbcLUX9TQWFhAL49Dt/JsFMaj2PnybiDY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)