UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WCIAlrD6zaIOAGcQphSq8qslue6kr4+TDlDUNFcMCug='
WHERE
key_id = '9940c53abb786e0c812155a00eda5b481e247f87181b921f50b902a4b911666d'
AND (
token = 'WCIAlrD6zaIOAGcQphSq8qslue6kr4+TDlDUNFcMCug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)