SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8700790137fd320186924f289a156aee4596e12b7eb8aa98b8f626e080d7c9e7' 
  AND token = 'IqgFI0mQX8YpzYAqQ7Dlz25ofC+k4fJzlEGh3u+b9NQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}