SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e83fcf76d184ea5b22552b01a39ad593f77844f5a2d4e454d50c79950be5871c' 
  AND token = 'asAPnUp+m7Zpll+43Q9WCX0k9pZEAXZ/+6K1maKvXpQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

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