SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6efcf1794bd579c9b9ee483ebdd09ce16f9c2dcf8471fd3b94fbf35d4d06d0bb' 
  AND token = 'iFgk4MU48xPhSo74DEmW7qMq48jhJ3QJ6TbtT4MsRVs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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