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())
  )

Query time 0.00009