SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'f63e2b41d0ff6d06ef95be9d49f2e70844d66d073aa8fe9c7e33b65779749dcb' 
  AND token = 'X14hvufruPoqBKAAdYecMYpwiNONB7Z3qawBcwWjJEA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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