UPDATE
vi_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MbGj4Ifmk9hNKPM6frSrPm4C7hlLKk38IGBr8bduLno='
WHERE
key_id = '4bae1f7873e32fb975f1acb84d7725e8e15ae230f764e416cfa5c93d55407443'
AND (
token = 'MbGj4Ifmk9hNKPM6frSrPm4C7hlLKk38IGBr8bduLno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)