SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2583955231e7a9dc4c3b6bc38fd187bf51f04ca393f38c4719177a8d85970c09' 
  AND token = 'ilKk7Uc9nQnoJh3RKH/Zft2h/QDIvQ+IhqX1uFFyAyE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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