SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '50ea013d4e3a6e0d7946764756f61214b8c5ff5cc0e08008ea78dfd4f98b4a6b' 
  AND token = '9K/pH0QBJtKJQm5ltoURUk3B5q+H3Ap3ytOoD7oOKuY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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