UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BW6SQ1vyn2b1mqBu0D5gyuHiOxA2/Wme/WF/AhL2Sgw='
WHERE
key_id = '5e9107f44d5e6ebebbfbbd5e41ef3ddc314df4367bd1a78e85cf846f799294d6'
AND (
token = 'BW6SQ1vyn2b1mqBu0D5gyuHiOxA2/Wme/WF/AhL2Sgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)