UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'jL/vfsts7CwHToTbiv/HxU8E1MYj6ss3x9ucN2Q3qus=' 
WHERE 
  key_id = 'c887ffe118070a97c4bab0a8c9d78853e4bfad2d509e2e11090e486422b86124' 
  AND (
    token = 'jL/vfsts7CwHToTbiv/HxU8E1MYj6ss3x9ucN2Q3qus=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034