SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e4152b7c23aa27ba404f8ac3d1d90be79981c87ba868dd97c5faf06608a2fb5d' 
  AND token = 'pJ6JW0WE2SAecDW1Lu1GugWJPNmzOZPWw0Pm5/ySjdc=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00038

JSON explain

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