SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '69ce7998315ab483e7a54d8b1153ab9f583b547f0ca9df58a17a910c3ea14ec9' 
  AND token = 'm0T7htzj95ece/DB2tN5VFSt42gkFixB0y9n9P20LX0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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