UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Qu+nRI9EdUJ9FWVF9K52szoD21aCdAMDoMTL2qv3stE=' 
WHERE 
  key_id = 'dd2ca6a62f1cea07213b18141905b805169754985bf1bad39000eb5580cae334' 
  AND (
    token = 'Qu+nRI9EdUJ9FWVF9K52szoD21aCdAMDoMTL2qv3stE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011