UPDATE 
  vi_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ehwCA+nNa70DmiM//3zW5J2rJIJt12Aq5GtQg43nGmw=' 
WHERE 
  key_id = 'caaa88ec2f090ab9f5043da0ca01d9191ebe0a8db142f8055e1752925a0eb2d7' 
  AND (
    token = 'ehwCA+nNa70DmiM//3zW5J2rJIJt12Aq5GtQg43nGmw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00010