SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3dfc09a1ce6adc7be4fe3dd2d5183102035d4b69b104576f277f381bcc157a7c' 
  AND token = '5Hn1RlFvzHxK/As3zfx1pd24KOujmJATyUjNkYjMFgM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00046

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}