UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/Iy5/Hv07xg/c9rF3E+ac/8Zg9ggKF3/5/0xDQZiJjg=' 
WHERE 
  key_id = '8f3028459bb76da9cc419d8e12c7f651e82c04fc2c06cc7dbc7805a8df5a45a2' 
  AND (
    token = '/Iy5/Hv07xg/c9rF3E+ac/8Zg9ggKF3/5/0xDQZiJjg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00459